CustomerAccountTenderLineItem

Entity Definition

Logical Name : CustomerAccountTenderLineItem
Physical Name : TR_LTM_CTAC_TND

A sub-type of TenderLineItem whereby the RetailTransaction is tendered against a CustomerAccountCard or CustomerAccount

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint
CustomerAccountID (FK) A unique identifier for a customer account. ID_CTAC Identity integer CustomerAccount(LE_CTAC)
CustomerAccountInvoiceID (FK) A unique system assigned identifier for the CustomerAccountInvoice ID_INVC_CTAC Identity integer CustomerAccountInvoice(DO_INVC_CTAC)
CustomerRepresentativeID (FK) A customer assigned identifier for the Driver fueling the vehicle. ID_CT_RPS Identity integer CustomerAgent(PA_CT_RPS)
CustomerAccountCardID (FK) A 16 digit Credit or Debit card PAN as defined by ISO-7812, uniquely identifying CustomerAccountCard. AI_ACNT_CT_CRD CreditDebitCardPAN varchar(20) CustomerAccountCard(LE_ACNT_CT_CRD)

Relationships

Parent Entity Verb Phrase Child Entity
CustomerAccountInvoice summarizes charges from CustomerAccountTenderLineItem
CustomerAccountCard is charged to CustomerAccountTenderLineItem
CustomerAccount is charged to CustomerAccountTenderLineItem
CustomerAgent performed CustomerAccountTenderLineItem
CustomerAccountTenderLineItem includes CustomerPurchaseOrder
TenderLineItem can be a CustomerAccountTenderLineItem

Logical Views containing CustomerAccountTenderLineItem

Logical View
Logical 02330 - Retail Transaction - Tender - Macro View
Logical 02339 - Retail Transaction - Tender - Account View
Logical 04100 - Financial Ledger - Retail Transaction View
Logical 07040 - Customer Segment Dependent Behavior
Logical 07200 - Customer Purchase Transaction History View